How to: Delete a data series in an Excel chart.
Solution:
Select the chart, select the data series, and press DELETE.
1) Select the desired chart:
a) If the chart is embedded on the worksheet, double-click on the chart. (A striped border with handles appears around the chart.)
b) If the chart is on a separate chart sheet, click the tab for the chart sheet.
2) Select (click on) the data series to delete.
3) Press DELETE.
